Setting general connection properties

This section describes how to configure general connection properties. For an explanation of how to configure advanced connection properties, see Setting advanced connection properties.

To add a SAP Sybase ASE source endpoint to Qlik Replicate:

1. In the Qlik Replicate Console, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box. Then click the New Endpoint Connection button. For more information on adding an endpoint to Qlik Replicate, see Defining and managing endpoints.
2. In the Name field, type a name for your database. This can be any name that will help to identify the database being used.
3. In the Description field, type a description that helps to identify the SAP Sybase ASE database. This is optional.

4. Select Source as the endpoint role.

5. Select SAP Sybase ASE as the database Type.

   Information note

   When this endpoint is used as a duplicated source in a Log Stream Staging setup, select the Read changes from log stream check box and then select the relevant Log Stream Staging task from the drop-down list.

   For information on setting up and managing Log Stream Staging tasks, see Using the Log Stream.

6. In the Server Name field, enter the host name or IP address of the computer on which the SAP Sybase ASE database is installed.

   Information note

   Consider the following:

   • This information is case sensitive.

   • You can use the Advanced tab to add specific properties and create a custom connect string. In this case, you do not need to enter information in this tab. For more information on using the Advanced tab, see Setting advanced connection properties.

   • To determine if you are connected to the database you want to use or if the connection information you entered is correct, click Test Connection

     If the connection is successful a message in green is displayed. If the connection fails, an error message is displayed at the bottom of the dialog box.

     To view the log entry if the connection fails, click View Log. The server log is displayed with the information for the connection failure. Note that this button is not available unless the test connection fails.

7. Optionally, change the default port (5000).

8. Type the SAP Sybase ASE authentication information (User Name, Password) for the authorized user for this SAP Sybase ASE database. If you do not know this information, see your SAP Sybase ASE database Administrator (DBA).

   Information note

   Consider the following:

   • This information is case sensitive.

   • This information is required. If you are using the Advanced tab to create a custom string, make sure to include the User Name and Password properties. See Setting advanced connection properties for more information.

   • If you want to set custom properties for this database, see Setting advanced connection properties.

   Information note

   Make sure that the SAP Sybase ASE user entered in the SAP Sybase ASE Authentication section has the correct access privileges. For information on how to provide the required privileges, see Required permissions.

9. In the Database name field, enter the SAP Sybase ASE database name.